iLoADER |
HOME |
Table Definition exampleTable Definition example The table definition is added to the Control File or the Data Transformation file after the table declaration has been made and the Control File or Data Transformation file saved. When the file is saved, the table definition is saved as a txt file, either below the Control File or the Data Transformation file. Click the table txt file to add the table definition details either manually or using the Table Definition wizard. The table definition example below is for a file declared as Person.txt. TABLE = [test].[person] KEY = FID BEGIN TABLE_DEFINITION FID , TEXT , 0 , 8 FORENAME , TEXT , 8 , 20 SURNAME , TEXT , 28 , 30 GENDER , TEXT , 58 , 1 MARITAL STATUS , TEXT , 59 , 1 INCOME , TEXT , 60 , 8 OCCUPATION , TEXT , 68 , 2 HOL_ACTIVE , TEXT , 70 , 9 END TABLE_DEFINITION |
Online & Instructor-Led Courses | Training Videos | Webinar Recordings | ![]() |
|
![]() |
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice | ![]() ![]() ![]() |